BEGIN
	EXEC qa_drop_table [mtdRule]
END 

CREATE TABLE [dbo].[mtdRule](
	[RuleID] [bigint] IDENTITY(1,1) NOT NULL,
	[RuleCode] [nchar](10) NOT NULL,
	[RuleName] [nchar](30) NULL,
	[Formula] [nchar](100) NULL,
	[ProcName] [nchar](30) NULL,
	[Param1] [nchar](10) NULL,
	[Param2] [nchar](10) NULL,
	[Param3] [nchar](10) NULL,
 CONSTRAINT [PK_Rule] PRIMARY KEY CLUSTERED 
(
	[RuleID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
 CONSTRAINT [UK_Rule] UNIQUE NONCLUSTERED 
(
	[RuleCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

